Select from the following for information on how and what CDR data is output:
Records included in a CDR output
Only enrolments matching the following criteria are considered in CDR generation:
-
The enrolment start and end dates must overlap with the academic year
AND
-
The enrolment UIO has a Qual Aim (UIO_CDR.QUAL_AIM) that is not NULL
AND
-
The Include in CDR check box is selected on the Enrolment Details screen in the Enrolments module
AND
-
The Progress Code is 'COMP', 'ENROL', 'TRAN', 'TRANS', or 'WTHD'
Exclude an individual enrolment
The Department for Education (DfE) in Northern Ireland expect enrolments to be included in the CDR return when the learner status is set to one of four statuses.
The learner statuses that are expected to be included in the CDR return are described in the following table.
| Learner status | Progress type |
|---|---|
| Continuing | A (Active) |
| Completed | F (Finished) |
| Withdrawn | W (Withdrawn) |
| Transferred | T (Transferred) |
You can exclude enrolments that you do not want to include in your CDR return (for example: cancelled, Online Payment Pending (OLPP), and so on).
To exclude an individual enrolment:
-
Select the Enrolments Details tab in the Enrolments module for the relevant learner.
-
Deselect the Include in CDR check box.
-
Click Save.
The enrolment is excluded from the CDR return.
Exclude multiple enrolments
The Department for Education (DfE) in Northern Ireland expect enrolments to be included in the CDR return when the learner status is set to one of four statuses.
The learner statuses that are expected to be included in the CDR return are described in the following table.
| Learner status | Progress type |
|---|---|
| Continuing | A (Active) |
| Completed | F (Finished) |
| Withdrawn | W (Withdrawn) |
| Transferred | T (Transferred) |
You can exclude enrolments that you do not want to include in your CDR return (for example: cancelled, Online Payment Pending (OLPP), and so on).
To exclude multiple enrolments:
-
Select the Enrolments tab in the Learner Manager module.
-
Use the Condition Builder to select the relevant enrolment Progress Code to exclude from the CDR return and then click Search button.
-
Deselect the Include in CDR check box in the first row to exclude multiple rows. Alternatively, deselect the relevant rows.
-
Click the Flood Fill button.
The Copy Selected Value window is displayed.
-
Select the relevant option, whether to flood fill all rows or all rows below the selected row.
The value displayed in the 'Include in CDR' column is updated.
- Click Save.
The deselected enrolments are excluded from the CDR return.
Fields included in the CDR output
The fields applicable to the CDR are described in the following table.
| CDR Return Column | CDR Field Name | EBS Source |
|---|---|---|
| 1 | ULN | PEOPLE.UNIQUE_LEARN_NO |
| 2 | STUDENT_ID | PERSON_CODE |
| 3 | ACAD_PERIOD | FUNDING_YEAR |
| 4 | ACAD_START_DT | Funding year start |
| 5 | ACAD_END_DT | Funding year end |
| 6 | TITLE | TITLE |
| 7 | FORENAME | Forename and Middle Name(s) |
| 8 | SURNAME | SURNAME |
| 9 | BIRTH_DATE | DOB |
| 10 | SEX | SEX |
| 11 | POSTCODE | Home address Postcode |
| 12 | MARITAL_STATUS | PEOPLE.Marital_Status |
| 13 | DEP_CHILD | PEOPLE_CDR.HAS_DEPENDENT_CHILD |
| 14 | DEP_ADULT | PEOPLE_CDR.HAS_DEPENDENT_ADULT |
| 15 | DEP_NO_CARE | PEOPLE_CDR.HAS_NO_DEPENDANTS |
| 16 | DEP_DISABILITY | PEOPLE_CDR.HAS_DISABLED_DEPENDANT |
| 17 | DEP_NOT_STATED | PEOPLE_CDR.HAS_NO_DEPENDANTS |
| 18 | REL_BROUGHT | People.Religion, taking into account people_CDR_History |
| 19 | ETHNICITY | PEOPLE_CDR.ETHNIC_ORIGIN |
| 20 | DOMICILE | PEOPLE_CDR.DOMICILE |
| 21 | CARE_BACK | PEOPLE_CDR.CARE_BACKGROUND, taking into account people_CDR_History |
| 22 | EMP_STATUS | PEOPLE.EMPLOY_STATUS_BEGIN |
| 23 | QUAL_LEV_ENTRY | PEOPLE.Prior_Education_Achievement, taking into account people_CDR_History |
| 24 | QUALS_ON_ENTRY | People.Level_of_Qualification, taking into account people_CDR_History |
| 25 | DISABILITY | PEOPLE_CDR.HAS_DISABILITY, taking into account people_CDR_History |
| 26 | STUDENT_DISAB | Top three DISABILITY_TYPE values from DISABILITIES, taking into account Person_Code and DATE |
| 27 | COLL_REF | Inst Setting FES_FEFC_REF and VER IFIIERS.LOW_VALUE |
| 28 | COLLEGE_NAME |
VERIFIIERS.ABBREVIATION RV_DOMAIN = 'COLL_REF' |
| 29 | PROG_OF_STUDY |
CDR_VERIFIIERS.DESCRIPTION Where RV_DOMAIN = 'PROG_CODE' Joined through enrolment hierarchy |
| 30 | PROG_CODE |
UIO_CDR.PROG_CODE Joined through enrolment hierarchy |
| 31 | PROG_YEAR |
UIO_CDR.PROG_YEAR Joined through enrolment hierarchy |
| 32 | PROG_FAST_TRACK | PEOPLE_UNITS_CDR.PROG_FAST_TRACK |
| 33 | PROG_ACHIEVEMENT | PEOPLE_UNITS_CDR.PROG_ACHIEVEMENT |
| 34 | SUBJECT_CODE | UIO_CDR.SUBJECT_CODE |
| 35 | LVL | UIO_CDR.QUAL_LEVEL |
| 36 | COURSE_MOA | Unit_Instances.FES_MOA_Code |
| 37 | STUDENT_MOA | People_Units.Mode_of_Attendance |
| 38 | EXP_LENGTH | Unit_Instance_Occurrences.Fes_Length |
| 39 | UNIT_LENGTH | Unit_Instances.Fes_units_Of_Length |
| 40 | SESS_TITLE | UIO_CDR.FULL_DESCRIPTION |
| 41 | MAIN_CAMPUS | UIO_CDR.MAIN_CAMPUS |
| 42 | CAMPUS_ID | UI.SLOC_LOCATION_CODE |
| 43 | STUDENT_STATUS | CDR_VERIFIERS.CODE where RV_DOMAIN='COURSE_STATUS' mapped from People_Units.Progress_Status |
| 44 | YRS_ON_COURSE | NVL(PEOPLE_UNITS_CDR.YEAR_OF_UNIT, UNIT_INSTANCE_OCCURRENCES.YEAR_OF_UNIT) |
| 45 | NO_OF_WEEKS | UIO.FES_NO_WEEKS |
| 46 | HRS_PER_WEEK | UIO.FES_NO_OF_HOURS |
| 47 | TOTAL_HRS | UIO.FES_POSSIBLE_HOURS |
| 48 | COURSE_SOF | UIO_CDR.SOURCE_OF_FUNDING |
| 49 | STUDENT_SOF | People_Units_CDR.STUDENT_TYPE |
| 50 | ES_FUND_FLAG | NVL(PEOPLE_UNITS_CDR.ES_FUND_FLAG, UNIT_INSTANCE_OCCURRENCES.ES_FUND_FLAG) |
| 51 | SLDD | PEOPLE_UNITS_CDR.SLDD |
| 52 | TAKE_EXAM_YN | People_Units_CDR.Take_Exam_YN |
| 54 | AWARD_DATE | PEOPLE_UNITS_CDR.AWARD_DATE if populated, else EXAM_ENTRIES.AWARD_DATE |
| 55 | EXAM_BRD_GRADE | Exam_entries.FIRST_Grade |
| 56 | QUAL_AIM | UIO_CDR.QUAL_AIM |
| 57 | DESTINATION | PEOPLE_UNITS.DESTINATION |
| 58 | COURSE_STATUS_DT | PEOPLE_UNITS.PROGRESS_DATE |
| 59 | LEAVE_REASON | PEOPLE_UNITS_CDR.LEAVE_REASON |
| 60 | AOS_START_DT | UIO.FES_START_DATE |
| 61 | START_DATE | NVL(PUS.START_DATE, UIO.FES_START_DATE) |
| 62 | AOS_END_DT | UIO.FES_END_DATE |
| 63 | END_DATE | When PU.PROGRESS_STATUS= 'A' then ISNULL(PUS.END_DATE,UIO.FES_END_DATE), else PU.PROGRESS_DATE |
| 64 | RETURN_IND | PEOPLE_UNITS_CDR.RETURN_IND |
| 65 | ASSESS_LVL | PEOPLE_UNITS_CDR.ASSESS_LEVEL |
| 66 | TARGET_LVL | PEOPLE_UNITS_CDR.TARGET_LEVEL |
| 67 | ACHIEVE_LVL |
PEOPLE_UNITS_CDR.ACHIEVED_LEVEL For any qualification with a qualification aim of 960, 961, or 962, that are essential skills, the PEOPLE_UNITS_CDR.ACHIEVED_LEVEL will be populated to match the value of EXAM_ENTRIES.FIRST_GRADE. The EXAM_ENTRIES.FIRST_GRADE value is retrieved from the First Grade field in Exams Manager > Exam Results. |
| 68 | AOS_CODE | UIO.FES_UINS_INSTANCE_CODE |
| 69 | AOS_PERIOD | UIO.CALOCC_OCCURRENCE_CODE |
| 70 | COLLEGE_SSATIER2 | UIO_CDR.COLLEGE_SSATIER2 |
| 71 | BOARD_CODE | Derive from the related exam entry |
| 72 | BOARD_NAME | Derive from the Board_Code in Column71 |
| 73 | COURSE_TITLE | First 200 characters of UNIT_INSTANCES.FULL_DESCRIPTION |
| 74 | DEPT_CODE | UIO.OWNING_ORGANISATION |
| 75 | DEPT_DESC | ORGANISATION_UNITS.FES_FULL_NAME (mapped from Column74) |
| 76 | QUAL_TYPE_CODE | UIO_CDR.QUAL_TYPE_CODE |
| 77 | RRQ_PL_CODE | UIO_CDR.PL_CODE |
| 78 | RRQ_PL_TITLE | From lookup to RRQ reference data using RRQ_PL_CODE in Column77 |
| 79 | PRIORITY_AREA | PROPERTY_VALUE from CDR_VERIFIER_PROPERTIES where RV_DOMAIN = 'SUBJECT_CODE' and PROPERTY_NAME = 'PRIORITY_AREA' and CODE = UCDR.SUBJECT_CODE |
| 80 | RRQ_SSATIER2 | UIO_CDR.RRQ_SSATIER2 |
| 81 | EQUIV_LVL |
CASE WHEN UCDR.QUAL_AIM IN ('960', '961', '962') AND PUCDR.TARGET_LEVEL IN ('EL1', 'EL2', 'EL3', 'L1','L2') THEN CASE WHEN PUCDR.TARGET_LEVEL IN ('EL1', 'EL2', 'EL3') THEN 0 WHEN PUCDR.TARGET_LEVEL IN ('L1') THEN 1 WHEN PUCDR.TARGET_LEVEL IN ('L2') THEN 2 END ELSE COALESCE( CASE WHEN UCDR.PL_CODE IS NOT NULL AND ISNUMERIC(LEFT(UCDR.PL_CODE,1)) = 1 THEN (SELECT TOP 1 CDRV.CODE FROM RRQ_QUALIFICATIONS RQ LEFT JOIN CDR_VERIFIERS CDRV ON RQ.QUAL_LEVEL = CDRV.DESCRIPTION WHERE RQ.QUALIFICATION_NUMBER = UCDR.PL_CODE AND CDRV.RV_DOMAIN = 'EQUIV_LVL') WHEN UCDR.PL_CODE IS NOT NULL AND LEFT(UCDR.PL_CODE,1) LIKE '%[A-Za-z]%' THEN (SELECT TOP 1 CDRV.CODE FROM RRQ_UNITS RU LEFT JOIN CDR_VERIFIERS CDRV ON RU.UNIT_LEVEL = CDRV.DESCRIPTION WHERE UNIQUE_REFERENCE_NUMBER = UCDR.PL_CODE AND CDRV.RV_DOMAIN = 'EQUIV_LVL') ELSE NULL END , UCDR.QUAL_LEVEL , '') |
| 82 | GUIDED_LEARNING_HOURS | UIO_CDR.GUIDED_LEARNING_HOURS |
| 83 | FEE_WAIVER | FEE_WAIVERS.WAIVER_CODE |
| 84 | GEOLOCN_CODE | UIO.SLOC_LOCATION_CODE |
| 85 | GEOLOCN_DESC | LOCATIONS.FES_LONG_DESCRIPTION Where LOCATION_CODE= value from Column84 |
| 86 | PREV_INST_CODE | PEOPLE.SCHOOL |
| 87 | PREV_INST_NAME | SCHOOLS.FULL_NAME derived from Column86 |
| 88 | PREV_INST_REF_CODE | Hard-coded to 'R19/20' |
| 89 | E_REG_HRS | Currently NULL as of 4.33 |
| 90 | ACT_C_HRS | Course_Hours from HOURS_STATISTICS |
| 91 | ACT_S_HRS | Student_Hours from HOURS_STATISTICS |
| 92 | NOT_C_HRS | UIO_CDR.NOTIONAL_HOURS |
| 93 | NOT_S_HRS | NOTIONAL_STUDENT_HOURS from HOURS_STATISTICS |
| 94 | TOTAL_S_HRS | TOTAL_STUDENT_HOURS from HOURS_STATISTICS |
| 95 | TENHOUR_IND | CASE WHEN (UIO.FES_POSSIBLE_HOURS >= 10) THEN 1 ELSE 0 |
| 96 | VIR_HRS | NULL as of 4.33 |
| 97 | WEEKS_ON_COURSE | Hard-coded to 'R19/20' |
| 98 | FEI_1 | When enrolment MOA in (01, 1) then if enrolment is active on reference date Return 1, Else Return 0 |
| 99 | FEI_2 | When enrolment MOA in (01, 1) then if enrolment is active on reference date Return 1, Else Return 1 |
| 100 | FEI_3 | When enrolment MOA in (01, 1) then if enrolment is active on reference date Return 1, Else Return 2 |
| 101 | ENTRY_LEVEL_ICT |
Default value = 0 Set to 1 if RRQ_PL_CODE is any of the following: '500/5886/1', '500/8483/5', '500/5694/3', '600/8223/9' |
| 102 | ECONOMIC_WTG | Hard-coded to 'R19/20' |
| 103 | LEVEL WTG | Hard-coded to 'R19/20' |
| 104 | FESR_YN | Default value 0. Set to 1 if QUAL_AIM is not null |
| 105 | FINAL_YEAR | Default value 0. Set to 1 where UNIT_LENGTH is days or weeks (value ‘1’ or ‘2’) OR UNIT_LENGTH = ‘4’ (years) and EXP_LENGTH = 1 OR UNIT_LENGTH ='4' AND EXP_LENGTH >1AND YRS_ON_COURSE >= EXP_LENGTH |
| 106 | ESER_YN |
Default value 0 Set to 1 if UIO_CDR.QUAL_AIM is '960', '961' or '962' |
| 107 | MAINSTREAM_YN | WHEN PEOPLE_UNITS_CDR.SOURCE_OF_FUNDING IN ('07', '7', '18', '40', '99') AND (COALESCE(PEOPLE_UNITS_CDR.ES_FUND_FLAG, UIO_CDR.ES_FUND_FLAG)= 1 OR UIO_CDR.QUAL_AIM IN ('960', '961', '962' )) THEN '1' ELSE '0' |
| 108 | EF_YN | Default value 0. Set to 1 if a QUAL_AIM is present AND student_type is ('02', '20') |
| 109 | OFQUALLVL |
Default Value of 0 OFQUALLVL= 1 (Unit) if the first character of RRQ_PL_CODE is a letter [A-Z] OFQUALLVL = 2 (Qualification) if the first character of RRQ_PL_CODE is a number Finally records, starting with a ‘P’, which are PLAQ/ACCESS records, the 1 will be overwritten with a 3 OFQUALLVL = 3 (PLAQ/ACCESS) if theRRQ_PL_CODE is in ('P10001' to 'P10013', 'P10021' to 'P10033', 'P10041', or 'P20051' to 'P20078') |
| 110 | REGULATED | WHEN UCDR.PL_CODE IS NOT NULL OR CAST(UCDR.QUAL_LEVEL as INT) >= 4 THEN 1 ELSE 0 |
| 111 | BROADSTEMIND | BROADSTEMIND =1 if the first character of SUBJECT_CODE is one of the following values ('A','B','C','D','E','F','G','H','I','J','K') otherwise 0 |
| 112 | NARROWSTEMIND | NARROWSTEMIND =1 if the first character of SUBJECT_CODE is one of the following values ('C','F','G','H','J') otherwise 0 |
| 113 | ACADIND | WHEN UIO_CDR.QUAL_AIM IN('560','614', '615') THEN 1 ELSE 0 |
| 114 | LP_FINYR_COMP |
CASE WHEN(UI.FES_UNITS_OF_LENGTH = '1' OR UI.FES_UNITS_OF_LENGTH = '2') AND (PU.PROGRESS_STATUS = 'A' OR PU.PROGRESS_STATUS = 'F' OR PU.PROGRESS_STATUS = 'W') AND (PUCDR.OUTCOME = '1' OR PUCDR.OUTCOME = '2') THEN 1 WHEN UI.FES_UNITS_OF_LENGTH = '4' AND UIO.FES_LENGTH = 1 AND (PU.PROGRESS_STATUS = 'A' OR PU.PROGRESS_STATUS = 'F' OR PU.PROGRESS_STATUS = 'W') AND (PUCDR.OUTCOME = '1' OR PUCDR.OUTCOME = '2') THEN 1 WHEN UI.FES_UNITS_OF_LENGTH = '4' AND UIO.FES_LENGTH > 1 AND (PUCDR.YEAR_OF_UNIT > 1 OR UIO.YEAR_OF_UNIT > 1) AND (PU.PROGRESS_STATUS = 'A' OR PU.PROGRESS_STATUS = 'F' OR PU.PROGRESS_STATUS = 'W') AND (PUCDR.OUTCOME = '1' OR PUCDR.OUTCOME = '2')THEN 1 ELSE 0 |
| 115 | FULLACHIEVEIND | FULLACHIEVEIND =1 if OUTCOME is 1 , otherwise 0 |
| 116 | ACHIEVEIND | ACHIEVEIND =1 if OUTCOME is in (‘1’,’2’), otherwise 0 |
| 117 | FINALYRCOMP_ACH | FINALYRCOMP_ACH = 1 if FINALYRCOMP = 1 AND OUTCOME is in (‘1’,’2’), otherwise 0 |
| 118 | WTH_ACH | WTH_ACH = 1 if STUDENT_STATUS =3 AND OUTCOME is in ('1','2'), otherwise 0 |
| 119 | STUD_WTH_PER | Hard-coded to 'R19/20' |
| 120 | FINALYR_LP1 | FINALYR_LP1 = 1 if FELS_YN =1 AND FEI_1 = 1, otherwise 0 |
| 121 | LP_FINAL_COMP | LP_FINAL_COMP = 1 ifFINALYRCOMP=1 AND FEI_1 = 1, otherwise 0 |
| 122 | LP_FINYR_COMP_ACH | FINALYRCOMP_ACH = 1 if FINALYRCOMP = 1 AND OUTCOME is in (‘1’,’2’), otherwise 0 |
| 123 | FT_PT | FT_PT = ‘FT’ if FLU_ATTEND_MODE [a.k.a. STUDENT_MOA] is '01' FT_PT = ‘PT’ if FLU_ATTEND_MODE [a.k.a. STUDENT_MOA] is not '01' |
| 124 | SUBJCODEAREA | SUBJCODEAREA = First Character of the SUBJECT_CODE |
| 125 | JULYAGE | AGE of student as at 1 July of the previous academic year |
| 126 | ENROLMENT | ENROLMENT = 1 against each record |
| 127 | PROVISION_AREA |
Default value = 0 ESER_YN=0 & Equiv_lvl <= 3 THEN 1 ESER_YN=0 & Equiv_lvl >= 4 THEN 2 ESER_YN = 1 THEN 3 |
| 128 | RELIGIOUS_BELIEF | PEOPLE_CDR.RELIGION |
| 129 | SEXUAL_ORIENTATION | PEOPLE_CDR.SEXUAL_ORIENTATION |
| 131 | LGD1992 | Selected from Postcode directory indexed on student home postcode |
| 132 | LGD1992NAME | Selected from Postcode directory indexed on student home postcode |
| 133 | LGD2014 | Selected from Postcode directory indexed on student home postcode |
| 134 | LGD2014NAME | Selected from Postcode directory indexed on student home postcode |
| 135 | WARD1992 | Selected from Postcode directory indexed on student home postcode |
| 136 | WARD1992NAME | Selected from Postcode directory indexed on student home postcode |
| 137 | WARD2014 | Selected from Postcode directory indexed on student home postcode |
| 138 | WARD2014NAME | Selected from Postcode directory indexed on student home postcode |
| 139 | AA2008 | Selected from Postcode directory indexed on student home postcode |
| 140 | AA2008NAME | Selected from Postcode directory indexed on student home postcode |
| 141 | SOA2001 | Selected from Postcode directory indexed on student home postcode |
| 142 | SOA_NAME | Selected from Postcode directory indexed on student home postcode |
| 143 | URBAN_RURAL | Selected from Postcode directory indexed on student home postcode |
| 144 | FE | Set to 'N' if NVQ Level IN (4,5,6,7,8,9) ELSE 'Y' |
| 145 | AGE_BAND |
Derive from age WHEN stud_age >= 16 AND stud_age < 20 THEN '16 to 19' WHEN stud_age >= 20 THEN '20 and over' ELSE 'under 16' |
| 146 | NIMDM_RANK2010 | Set to 'N' if NVQ Level IN (4,5,6,7,8,9) ELSE 'Y' |
| 147 | NIMDM_QUINTILE2010 | Set to 'N' if NVQ Level IN (4,5,6,7,8,9) ELSE 'Y' |
| 148 | NIMDM_RANK2017 | Set to 'N' if NVQ Level IN (4,5,6,7,8,9) ELSE 'Y' |
| 149 | NIMDM_QUINTILE2017 | Set to 'N' if NVQ Level IN (4,5,6,7,8,9) ELSE 'Y' |
| 150 | ImmigrationStatus | PEOPLE_CDR.IMMIGRATION_STATUS taking History into account |
| 151 | VPRS | PEOPLE_CDR.VPRS taking History into account |
| 152 | HeardAboutTheCourse | PEOPLE_UNITS _CDR.HEARD_ABOUT_COURSE |
| 153 | Alevel_GCSE | WHEN qual_aim IN ('554','558','559','564','565','566','567','614','615') Then 'A Level' WHEN qual_aim IN ('560','561') THEN 'GCSE' ELSE 'Other' |
| 154 | GCSEMathGrade | PEOPLE_CDR.GCSE_MATHS_GRADE taking History into account |
| 155 | GCSEEnglishGrade | PEOPLE_CDR.GCSE_ENGLISH_GRADE taking History into account |
| 156 | EssentialSkillsNumeracyGrade | PEOPLE_CDR.ESKILLS_NUMERACY taking History into account |
| 157 | EssentialSkillsLiteracyGrade | PEOPLE_CDR.ESKILLS_LITERACY taking History into account |
| 158 | ValErrorSummary | Concatenated comma-separated list of validation error refs for this record |
| 159 | ValWarningSummary | Concatenated comma-separated list of validation warning refs for this record |
| 160 | Employed_Household_YN | PEOPLE_CDR.EMPLOYED_HOUSEHOLD, taking history into account |
| 161 | Homeless_Exclusion | PEOPLE_CDR.HOMELESS_EXCLUSION, taking history into account |
| 162 | Long_Term_Destination | PEOPLE_CDR.LONG_TERM_DESTINATION, taking history into account |
| 163 | Long_Term_Employment | PEOPLE_CDR.LONG_TERM_EMPLOYMENT, taking history into account |
| 164 | NI_Number | PEOPLE.NI_NUMBER |
| 165 | STUDENT_E-MAIL | PEOPLE.PERSONAL_EMAIL |
| 166 | PC3 | Hard-coded to 'R19/20' |
| 167 | HLA Pathway | Coalesce(PEOPLE_UNITS_CDR.HLA_PATHWAY,UNIT_INSTANCE_OCCURRENCES.HLA_PATHWAY) |
| 168 | GCSE_A_C* | "PEOPLE_CDR.GCSE_A_C Taking into account people_CDR_History" |
| 169 | GCSE_D_G* | "PEOPLE_CDR.GCSE_D_G Taking into account people_CDR_History" |
| 170 | MODE_OF _DELIVERY* | coalesce(PEOPLE_UNITS.MODE_OF_ATTENDANCE, UNIT_INSTANCE_OCCURRENCES.FES_MOA_CODE) mapped to FullTime, PartTimeDay, PartTimeEvening through MOA_CODE CDR_VERIFIER_PROPERTIES |
| 171 | SPACE_FTE | TOTAL_S_HRS/693 for enrolments at Locations flagged as being Include_In_SpaceFTE='Y' and where the Mode_Of_Delivery is 'Daytime'. |
| 172 | AMS_FTE | Reserved for 2023-24. Currently returned empty. |
| 173 | HECOS_CODE* | UIO_CDR.HECOS_CODE for the enrolled Q-level course |
| 174 | CARE_LEAVER | "PEOPLE_CDR.CARE_LEAVER Taking into account people_CDR_History" |
| 175 | FT_IND | 1 if learner has any enrolment in the academic period where Student_MOA in ('01', '20') Else 0 |
| 176 | IND_SI | A flag set against one enrolment for each Social Inclusion Learner |
| 177 | IND_STU | A flag set against one enrolment for each non-Essential Skills Learner |
| 178 | IND_ES | A flag set against one enrolment for each Essential Skills Learner |
| 179 | IND_PSSA | A flag set against one enrolment for each Priority Skills Learner |
| 180 | AGE_BAND_NISRA | "Derived from Age. The Not Known value is output if the Learners Date of Birth is 01/01/1910. The aged bands to be derived are: 19 and Under 20-24 25 and over Not Known " |
| 181 | LEARNER_SUPPORT_FUNDING | A concatenated string of 2-char values from PEOPLE_UNIT_SUPPORT_FUNDING.LEARNER_SUPPORT_FUNDING_CODE |
| 182 | EMA_ID | PEOPLE.EMA_ID |
| 183 | CLIENT_ID | PEOPLE_CDR.CLIENT_ID |
| 184 | PARTICIPANT_ID | PEOPLE_UNITS_CDR.PARTICIPANT_ID |
| 185 | SOCIAL_INCLUSION | UIO_CDR.SOCIAL_INCLUSION (Default N) |
| 186 | TOTAL_QUAL_TIME | UIO_CDR.TOTAL_QUAL_TIME (truncated to 250 characters) |
| 187 | PROG_EXAM_BRD_GRADE | PEOPLE_UNITS_CDR.EXAM_BRD_GRADE |
| 188 | PROG_EXP_END_DATE | PEOPLE_UNITS_CDR.EXP_END_DATE |
| 189 | PROG_WP_COMPLETE | PEOPLE_UNITS_CDR.WP_COMPLETE |
| 190 | CURR_MODEL | UIO_CDR.CURRMODEL |
| 191 | ETI_AOS_CODE | UIO_CDR.ETI_AOS_CODE |
| 192 | GENDER_IDENTITY | PEOPLE_CDR.GENDER_IDENTITY |
| 193 | GCSEICTGrade | PEOPLE_CDR.GCSE_ICT_GRADE |
| 194 | EssentialSkillsICTLevel | PEOPLE_CDR.ESKILLS_ICT_LEVEL |
| 195 | PROGRESS_CODE | PEOPLE_UNITS.PROGRESS_CODE |
| 196 | CDP_KPI | Concatenated and space-separated values from UIO_CDP_KPI.CDP_KPI where UIO_CDP_KPI.UIO_ID=PEOPLE_UNITS.UIO_ID |
| 197 | MDM_Decile2010 | Selected from Postcode directory indexed on student home postcode. |
| 198 | MDM_Decile2017 | Selected from Postcode directory indexed on student home postcode. |
| 199 | LGD1992#LAU1 | Selected from Postcode directory indexed on student home postcode. |
| 200 | LGD1992#LAU1NAME | Selected from Postcode directory indexed on student home postcode. |
| 201 | HSCT_CODE | Selected from Postcode directory indexed on student home postcode. |
| 202 | HSCT_NAME | Selected from Postcode directory indexed on student home postcode. |
| 203 | DEA2014 | Selected from Postcode directory indexed on student home postcode. |
| 204 | DEA2014NAME | Selected from Postcode directory indexed on student home postcode. |
| 205 | WARD1992#LAU1 | Selected from Postcode directory indexed on student home postcode. |
| 206 | WARD1992#LAUNAME | Selected from Postcode directory indexed on student home postcode. |
| 207 | LAU2 | Selected from Postcode directory indexed on student home postcode. |
| 208 | LAU2NAME | Selected from Postcode directory indexed on student home postcode. |
| 209 | DZ2021 | Selected from Postcode directory indexed on student home postcode. |
| 210 | SDZ2021 | Selected from Postcode directory indexed on student home postcode. |
| 211 | PROG_WP_FORMAT | To be stored in the database with field name WP_COMPLETE |
| 212 | CDP_FT_PT | CDP_FT_PT = ‘FT’ if FLU_ATTEND_MODE [a.k.a. STUDENT_MOA] is '01' or ‘20’ CDP_FT_PT = ‘PT’ if FLU_ATTEND_MODE [a.k.a. STUDENT_MOA] is not '01' and is not ’20’ |
| 213 | ENR_CLAIM_DATE | |
| 214 | ACH_CLAIM_DATE | |
| 215 | NATIONAL_IDENTITY | PEOPLE_CDR.NATIONAL_IDENTITY |
| 216 | NATIONAL_IDENTITY_OTHER | PEOPLE_CDR.NATIONAL_IDENTITY_OTHER |
| 217 | MAIN_LANGUAGE | PEOPLE_CDR.MAIN_LANGUAGE |
| 218 | MAIN_LANGUAGE_OTHER | PEOPLE_CDR.MAIN_LANGUAGE_OTHER |
| 219 | SPEAK_ENGLISH | PEOPLE_CDR.SPEAK_ENGLISH |